SELECT
     Northwind_Mart.dbo.Time_Dim.Time_Key,
     Northwind_Mart.dbo.Shipper_Dim.Shipper_Key,
     Northwind_Mart.dbo.Product_Dim.Product_Key,
     Northwind_Mart.dbo.Employee_Dim.Employee_Key,      
     Northwind.dbo.Orders.RequiredDate,      
     Orders.Freight * [Order Details].Quantity /          
          (SELECT SUM(Quantity)
           FROM [Order Details] od
           WHERE od.OrderID = Orders.OrderID) AS LineItemFreight,
     [Order Details].UnitPrice * [Order Details].Quantity AS LineItemTotal,
     [Order Details].Quantity AS LineItemQuantity,
     [Order Details].Discount * [Order Details].UnitPrice *
          [Order Details].Quantity AS LineItemDiscount 
FROM Orders  

INNER JOIN [Order Details]
      ON Orders.OrderID = [Order Details].OrderID  
INNER JOIN Northwind_Mart.dbo.Product_Dim
      ON [Order Details].ProductID = 
      Northwind_Mart.dbo.Product_Dim.Product_ID  
INNER JOIN Northwind_Mart.dbo.Time_Dim
      ON Orders.ShippedDate = Northwind_Mart.dbo.Time_Dim.The_Date  
INNER JOIN Northwind_Mart.dbo.Shipper_Dim
      ON Orders.ShipVia = Northwind_Mart.dbo.Shipper_Dim.Shipper_ID  
INNER JOIN Northwind_Mart.dbo.Employee_Dim
      ON Orders.EmployeeID = 
      Northwind_Mart.dbo.Employee_Dim.Employee_ID  
WHERE (Orders.ShippedDate IS NOT NULL)
